oracle分析以下数据表,用两种办法(视图及存储过程)实现累计列Acc的运 ...答:视图:with t1 as ( select 1 as id,'一车队' name, '1' month, 10 amount from dual union all select 2,'一车队', '2', 20 from dual union all select 3,'一车队', '3', 40 from dual union all select 4,'机动车队', '1', 30 from dual union all select 5,'机动车队...
对Oracle数据库中查询出表的结果,实现如下效果答:WITH TAB AS(SELECT 'a1' AS A,'b1' AS B FROM DUAL UNION SELECT 'a2' AS A,'b2' AS B FROM DUAL )SELECT A,NULL AS B,DECODE(A,'a1',B,'') AS C,DECODE(A,'a2',B,'') D from tab;这是测试语句,真正的语句是去掉上面的WITH语句,如下:SELECT A,NULL AS B,DECODE(A,...